Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 2624 |
| Missing cells | 4607 |
| Missing cells (%) | 8.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 430.6 KiB |
| Average record size in memory | 168.0 B |
Variable types
| NUM | 16 |
|---|---|
| CAT | 4 |
| BOOL | 1 |
TempDist has 2351 (89.6%) missing values | Missing |
SpatDist has 2256 (86.0%) missing values | Missing |
Duration is highly skewed (γ1 = 29.48313023) | Skewed |
df_index has unique values | Unique |
AnzGesperrtFs has 763 (29.1%) zeros | Zeros |
Length has 756 (28.8%) zeros | Zeros |
Duration has 421 (16.0%) zeros | Zeros |
Reproduction
| Analysis started | 2020-11-20 11:05:30.649088 |
|---|---|
| Analysis finished | 2020-11-20 11:06:53.334306 |
| Duration | 1 minute and 22.69 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 2624 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1616.889863 |
|---|---|
| Minimum | 0 |
| Maximum | 3240 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 153.15 |
| Q1 | 774.75 |
| median | 1622.5 |
| Q3 | 2425.25 |
| 95-th percentile | 3084.85 |
| Maximum | 3240 |
| Range | 3240 |
| Interquartile range (IQR) | 1650.5 |
Descriptive statistics
| Standard deviation | 943.7679253 |
|---|---|
| Coefficient of variation (CV) | 0.58369339 |
| Kurtosis | -1.206850872 |
| Mean | 1616.889863 |
| Median Absolute Deviation (MAD) | 825.5 |
| Skewness | -0.005704106659 |
| Sum | 4242719 |
| Variance | 890697.8967 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 3135 | 1 | < 0.1% | |
| 3133 | 1 | < 0.1% | |
| 1084 | 1 | < 0.1% | |
| 3131 | 1 | < 0.1% | |
| 1082 | 1 | < 0.1% | |
| 3129 | 1 | < 0.1% | |
| 1080 | 1 | < 0.1% | |
| 3127 | 1 | < 0.1% | |
| 1078 | 1 | < 0.1% | |
| Other values (2614) | 2614 | 99.6% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3240 | 1 | < 0.1% | |
| 3238 | 1 | < 0.1% | |
| 3237 | 1 | < 0.1% | |
| 3236 | 1 | < 0.1% | |
| 3235 | 1 | < 0.1% |
TempMax
Real number (ℝ≥0)
| Distinct | 200 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 187.3365091 |
|---|---|
| Minimum | 9 |
| Maximum | 1326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 45 |
| median | 120 |
| Q3 | 228 |
| 95-th percentile | 636 |
| Maximum | 1326 |
| Range | 1317 |
| Interquartile range (IQR) | 183 |
Descriptive statistics
| Standard deviation | 217.5492178 |
|---|---|
| Coefficient of variation (CV) | 1.16127507 |
| Kurtosis | 8.194452249 |
| Mean | 187.3365091 |
| Median Absolute Deviation (MAD) | 81 |
| Skewness | 2.557774526 |
| Sum | 491571 |
| Variance | 47327.66217 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 144 | 5.5% | |
| 36 | 100 | 3.8% | |
| 189 | 67 | 2.6% | |
| 21 | 61 | 2.3% | |
| 24 | 58 | 2.2% | |
| 60 | 48 | 1.8% | |
| 48 | 46 | 1.8% | |
| 18 | 45 | 1.7% | |
| 57 | 41 | 1.6% | |
| 51 | 41 | 1.6% | |
| Other values (190) | 1973 | 75.2% |
| Value | Count | Frequency (%) | |
| 9 | 27 | 1.0% | |
| 12 | 19 | 0.7% | |
| 15 | 144 | 5.5% | |
| 18 | 45 | 1.7% | |
| 21 | 61 | 2.3% |
| Value | Count | Frequency (%) | |
| 1326 | 4 | 0.2% | |
| 1323 | 19 | 0.7% | |
| 1320 | 1 | < 0.1% | |
| 1194 | 1 | < 0.1% | |
| 1116 | 12 | 0.5% |
TempAvg
Real number (ℝ≥0)
| Distinct | 244 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.71989329 |
|---|---|
| Minimum | 5 |
| Maximum | 1326 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 22 |
| median | 53 |
| Q3 | 109 |
| 95-th percentile | 267.8 |
| Maximum | 1326 |
| Range | 1321 |
| Interquartile range (IQR) | 87 |
Descriptive statistics
| Standard deviation | 102.3310154 |
|---|---|
| Coefficient of variation (CV) | 1.193783747 |
| Kurtosis | 24.97426707 |
| Mean | 85.71989329 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 3.676119237 |
| Sum | 224929 |
| Variance | 10471.63672 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 15 | 141 | 5.4% | |
| 162 | 58 | 2.2% | |
| 31 | 58 | 2.2% | |
| 30 | 48 | 1.8% | |
| 12 | 45 | 1.7% | |
| 17 | 42 | 1.6% | |
| 18 | 42 | 1.6% | |
| 21 | 40 | 1.5% | |
| 9 | 38 | 1.4% | |
| 70 | 38 | 1.4% | |
| Other values (234) | 2074 | 79.0% |
| Value | Count | Frequency (%) | |
| 5 | 6 | 0.2% | |
| 6 | 31 | 1.2% | |
| 7 | 32 | 1.2% | |
| 8 | 27 | 1.0% | |
| 9 | 38 | 1.4% |
| Value | Count | Frequency (%) | |
| 1326 | 2 | 0.1% | |
| 966 | 2 | 0.1% | |
| 673 | 3 | 0.1% | |
| 581 | 4 | 0.2% | |
| 575 | 1 | < 0.1% |
SpatMax
Real number (ℝ≥0)
| Distinct | 1085 |
|---|---|
| Distinct (%) | 41.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9241.61471 |
|---|---|
| Minimum | 699 |
| Maximum | 49765 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 699 |
|---|---|
| 5-th percentile | 1641 |
| Q1 | 2831 |
| median | 5688 |
| Q3 | 12370.25 |
| 95-th percentile | 29357.1 |
| Maximum | 49765 |
| Range | 49066 |
| Interquartile range (IQR) | 9539.25 |
Descriptive statistics
| Standard deviation | 9219.142637 |
|---|---|
| Coefficient of variation (CV) | 0.9975683823 |
| Kurtosis | 3.404716733 |
| Mean | 9241.61471 |
| Median Absolute Deviation (MAD) | 3240 |
| Skewness | 1.843409412 |
| Sum | 24249997 |
| Variance | 84992590.96 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2831 | 110 | 4.2% | |
| 1926 | 53 | 2.0% | |
| 1014 | 39 | 1.5% | |
| 2908 | 24 | 0.9% | |
| 8459 | 22 | 0.8% | |
| 3306 | 20 | 0.8% | |
| 2226 | 19 | 0.7% | |
| 2475 | 19 | 0.7% | |
| 1903 | 14 | 0.5% | |
| 11282 | 14 | 0.5% | |
| Other values (1075) | 2290 | 87.3% |
| Value | Count | Frequency (%) | |
| 699 | 1 | < 0.1% | |
| 902 | 1 | < 0.1% | |
| 965 | 1 | < 0.1% | |
| 991 | 2 | 0.1% | |
| 1014 | 39 | 1.5% |
| Value | Count | Frequency (%) | |
| 49765 | 3 | 0.1% | |
| 48987 | 1 | < 0.1% | |
| 47607 | 6 | 0.2% | |
| 47196 | 3 | 0.1% | |
| 44751 | 1 | < 0.1% |
SpatAvg
Real number (ℝ≥0)
| Distinct | 1156 |
|---|---|
| Distinct (%) | 44.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3356.083841 |
|---|---|
| Minimum | 284 |
| Maximum | 15602 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 284 |
|---|---|
| 5-th percentile | 889 |
| Q1 | 1536 |
| median | 2378 |
| Q3 | 4210.25 |
| 95-th percentile | 9616 |
| Maximum | 15602 |
| Range | 15318 |
| Interquartile range (IQR) | 2674.25 |
Descriptive statistics
| Standard deviation | 2737.973423 |
|---|---|
| Coefficient of variation (CV) | 0.8158239043 |
| Kurtosis | 3.684917889 |
| Mean | 3356.083841 |
| Median Absolute Deviation (MAD) | 1011 |
| Skewness | 1.905024754 |
| Sum | 8806364 |
| Variance | 7496498.464 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1536 | 110 | 4.2% | |
| 1575 | 53 | 2.0% | |
| 809 | 39 | 1.5% | |
| 2691 | 21 | 0.8% | |
| 1683 | 20 | 0.8% | |
| 1276 | 17 | 0.6% | |
| 2469 | 15 | 0.6% | |
| 1272 | 15 | 0.6% | |
| 4430 | 14 | 0.5% | |
| 12363 | 13 | 0.5% | |
| Other values (1146) | 2307 | 87.9% |
| Value | Count | Frequency (%) | |
| 284 | 1 | < 0.1% | |
| 305 | 3 | 0.1% | |
| 355 | 1 | < 0.1% | |
| 404 | 1 | < 0.1% | |
| 457 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 15602 | 2 | 0.1% | |
| 15590 | 2 | 0.1% | |
| 15054 | 4 | 0.2% | |
| 14785 | 3 | 0.1% | |
| 14776 | 1 | < 0.1% |
| Distinct | 24 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 2351 |
| Missing (%) | 89.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.13186813 |
|---|---|
| Minimum | 1 |
| Maximum | 24 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 10 |
| Q3 | 15 |
| 95-th percentile | 22 |
| Maximum | 24 |
| Range | 23 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.039469672 |
|---|---|
| Coefficient of variation (CV) | 0.5425387366 |
| Kurtosis | -0.8019439214 |
| Mean | 11.13186813 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.3226704522 |
| Sum | 3039 |
| Variance | 36.47519392 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6 | 21 | 0.8% | |
| 9 | 20 | 0.8% | |
| 10 | 18 | 0.7% | |
| 7 | 16 | 0.6% | |
| 14 | 15 | 0.6% | |
| 11 | 14 | 0.5% | |
| 15 | 14 | 0.5% | |
| 3 | 13 | 0.5% | |
| 12 | 13 | 0.5% | |
| 8 | 12 | 0.5% | |
| Other values (14) | 117 | 4.5% | |
| (Missing) | 2351 | 89.6% |
| Value | Count | Frequency (%) | |
| 1 | 7 | 0.3% | |
| 2 | 9 | 0.3% | |
| 3 | 13 | 0.5% | |
| 4 | 12 | 0.5% | |
| 5 | 11 | 0.4% |
| Value | Count | Frequency (%) | |
| 24 | 6 | 0.2% | |
| 23 | 4 | 0.2% | |
| 22 | 5 | 0.2% | |
| 21 | 10 | 0.4% | |
| 20 | 10 | 0.4% |
| Distinct | 228 |
|---|---|
| Distinct (%) | 62.0% |
| Missing | 2256 |
| Missing (%) | 86.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 696.1902174 |
|---|---|
| Minimum | 1 |
| Maximum | 1988 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 34.05 |
| Q1 | 152 |
| median | 576 |
| Q3 | 1073.5 |
| 95-th percentile | 1843.15 |
| Maximum | 1988 |
| Range | 1987 |
| Interquartile range (IQR) | 921.5 |
Descriptive statistics
| Standard deviation | 583.0091878 |
|---|---|
| Coefficient of variation (CV) | 0.8374280092 |
| Kurtosis | -0.7157057295 |
| Mean | 696.1902174 |
| Median Absolute Deviation (MAD) | 454 |
| Skewness | 0.668566729 |
| Sum | 256198 |
| Variance | 339899.713 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 576 | 39 | 1.5% | |
| 92 | 38 | 1.4% | |
| 1025 | 17 | 0.6% | |
| 1985 | 7 | 0.3% | |
| 431 | 6 | 0.2% | |
| 1986 | 4 | 0.2% | |
| 1 | 4 | 0.2% | |
| 588 | 3 | 0.1% | |
| 182 | 3 | 0.1% | |
| 97 | 3 | 0.1% | |
| Other values (218) | 244 | 9.3% | |
| (Missing) | 2256 | 86.0% |
| Value | Count | Frequency (%) | |
| 1 | 4 | 0.2% | |
| 2 | 2 | 0.1% | |
| 5 | 2 | 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 1988 | 1 | < 0.1% | |
| 1986 | 4 | 0.2% | |
| 1985 | 7 | 0.3% | |
| 1982 | 1 | < 0.1% | |
| 1956 | 1 | < 0.1% |
Coverage
Real number (ℝ≥0)
| Distinct | 94 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.13033537 |
|---|---|
| Minimum | 4 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 14 |
| Q1 | 29 |
| median | 45 |
| Q3 | 62 |
| 95-th percentile | 85 |
| Maximum | 100 |
| Range | 96 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 21.97233752 |
|---|---|
| Coefficient of variation (CV) | 0.4763099455 |
| Kurtosis | -0.6621426759 |
| Mean | 46.13033537 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.341124255 |
| Sum | 121046 |
| Variance | 482.7836162 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 48 | 148 | 5.6% | |
| 35 | 78 | 3.0% | |
| 27 | 68 | 2.6% | |
| 85 | 65 | 2.5% | |
| 64 | 60 | 2.3% | |
| 79 | 58 | 2.2% | |
| 32 | 53 | 2.0% | |
| 34 | 52 | 2.0% | |
| 47 | 51 | 1.9% | |
| 38 | 48 | 1.8% | |
| Other values (84) | 1943 | 74.0% |
| Value | Count | Frequency (%) | |
| 4 | 3 | 0.1% | |
| 6 | 9 | 0.3% | |
| 7 | 9 | 0.3% | |
| 8 | 10 | 0.4% | |
| 9 | 13 | 0.5% |
| Value | Count | Frequency (%) | |
| 100 | 31 | 1.2% | |
| 99 | 1 | < 0.1% | |
| 97 | 3 | 0.1% | |
| 95 | 7 | 0.3% | |
| 94 | 6 | 0.2% |
TempGL
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.5 KiB |
| 3 | |
|---|---|
| 2 | |
| 1 | |
| 4 | 4 |
| Value | Count | Frequency (%) | |
| 3 | 1695 | 64.6% | |
| 2 | 643 | 24.5% | |
| 1 | 282 | 10.7% | |
| 4 | 4 | 0.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
SpatGL
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.5 KiB |
| 2 | |
|---|---|
| 3 |
| Value | Count | Frequency (%) | |
| 2 | 2256 | 86.0% | |
| 3 | 368 | 14.0% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
TempIL
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.068597561 |
|---|---|
| Minimum | -1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | -1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 6 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.369076773 |
|---|---|
| Coefficient of variation (CV) | 1.145257453 |
| Kurtosis | -1.552752615 |
| Mean | 2.068597561 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.3596672682 |
| Sum | 5428 |
| Variance | 5.612524758 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -1 | 929 | 35.4% | |
| 3 | 794 | 30.3% | |
| 4 | 482 | 18.4% | |
| 5 | 405 | 15.4% | |
| 2 | 8 | 0.3% | |
| 1 | 6 | 0.2% |
| Value | Count | Frequency (%) | |
| -1 | 929 | 35.4% | |
| 1 | 6 | 0.2% | |
| 2 | 8 | 0.3% | |
| 3 | 794 | 30.3% | |
| 4 | 482 | 18.4% |
| Value | Count | Frequency (%) | |
| 5 | 405 | 15.4% | |
| 4 | 482 | 18.4% | |
| 3 | 794 | 30.3% | |
| 2 | 8 | 0.3% | |
| 1 | 6 | 0.2% |
SpatIL
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.730182927 |
|---|---|
| Minimum | -1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | -1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.911397035 |
|---|---|
| Coefficient of variation (CV) | 0.7000985231 |
| Kurtosis | -0.4791336765 |
| Mean | 2.730182927 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.7049981926 |
| Sum | 7164 |
| Variance | 3.653438625 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 4 | 611 | 23.3% | |
| 2 | 539 | 20.5% | |
| 5 | 515 | 19.6% | |
| 3 | 422 | 16.1% | |
| -1 | 368 | 14.0% | |
| 1 | 169 | 6.4% |
| Value | Count | Frequency (%) | |
| -1 | 368 | 14.0% | |
| 1 | 169 | 6.4% | |
| 2 | 539 | 20.5% | |
| 3 | 422 | 16.1% | |
| 4 | 611 | 23.3% |
| Value | Count | Frequency (%) | |
| 5 | 515 | 19.6% | |
| 4 | 611 | 23.3% | |
| 3 | 422 | 16.1% | |
| 2 | 539 | 20.5% | |
| 1 | 169 | 6.4% |
TLCar
Real number (ℝ≥0)
| Distinct | 714 |
|---|---|
| Distinct (%) | 27.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1503.476372 |
|---|---|
| Minimum | 1000 |
| Maximum | 1999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 1051 |
| Q1 | 1277 |
| median | 1523 |
| Q3 | 1750 |
| 95-th percentile | 1938 |
| Maximum | 1999 |
| Range | 999 |
| Interquartile range (IQR) | 473 |
Descriptive statistics
| Standard deviation | 282.307127 |
|---|---|
| Coefficient of variation (CV) | 0.1877695801 |
| Kurtosis | -1.151516292 |
| Mean | 1503.476372 |
| Median Absolute Deviation (MAD) | 237 |
| Skewness | -0.06950558419 |
| Sum | 3945122 |
| Variance | 79697.31397 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1555 | 109 | 4.2% | |
| 1297 | 53 | 2.0% | |
| 1286 | 39 | 1.5% | |
| 1152 | 22 | 0.8% | |
| 1518 | 22 | 0.8% | |
| 1667 | 20 | 0.8% | |
| 1659 | 17 | 0.6% | |
| 1015 | 17 | 0.6% | |
| 1323 | 16 | 0.6% | |
| 1403 | 15 | 0.6% | |
| Other values (704) | 2294 | 87.4% |
| Value | Count | Frequency (%) | |
| 1000 | 3 | 0.1% | |
| 1001 | 10 | 0.4% | |
| 1003 | 5 | 0.2% | |
| 1004 | 3 | 0.1% | |
| 1005 | 4 | 0.2% |
| Value | Count | Frequency (%) | |
| 1999 | 1 | < 0.1% | |
| 1997 | 2 | 0.1% | |
| 1996 | 6 | 0.2% | |
| 1995 | 4 | 0.2% | |
| 1991 | 2 | 0.1% |
TLHGV
Real number (ℝ≥0)
| Distinct | 465 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 732.5560213 |
|---|---|
| Minimum | 500 |
| Maximum | 999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 513 |
| Q1 | 612 |
| median | 734.5 |
| Q3 | 849 |
| 95-th percentile | 971 |
| Maximum | 999 |
| Range | 499 |
| Interquartile range (IQR) | 237 |
Descriptive statistics
| Standard deviation | 143.8753826 |
|---|---|
| Coefficient of variation (CV) | 0.1964018838 |
| Kurtosis | -1.110121605 |
| Mean | 732.5560213 |
| Median Absolute Deviation (MAD) | 120.5 |
| Skewness | 0.1351401133 |
| Sum | 1922227 |
| Variance | 20700.12572 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 787 | 117 | 4.5% | |
| 505 | 55 | 2.1% | |
| 612 | 45 | 1.7% | |
| 738 | 32 | 1.2% | |
| 513 | 23 | 0.9% | |
| 987 | 22 | 0.8% | |
| 737 | 22 | 0.8% | |
| 671 | 19 | 0.7% | |
| 846 | 19 | 0.7% | |
| 571 | 19 | 0.7% | |
| Other values (455) | 2251 | 85.8% |
| Value | Count | Frequency (%) | |
| 500 | 5 | 0.2% | |
| 501 | 5 | 0.2% | |
| 502 | 9 | 0.3% | |
| 503 | 2 | 0.1% | |
| 504 | 4 | 0.2% |
| Value | Count | Frequency (%) | |
| 999 | 5 | 0.2% | |
| 998 | 2 | 0.1% | |
| 997 | 17 | 0.6% | |
| 996 | 7 | 0.3% | |
| 995 | 5 | 0.2% |
Strasse
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.5 KiB |
| A 3 | |
|---|---|
| A 9 | |
| A 7 | |
| A 99 | |
| A 96 | |
| Other values (12) |
| Value | Count | Frequency (%) | |
| A 3 | 884 | 33.7% | |
| A 9 | 562 | 21.4% | |
| A 7 | 239 | 9.1% | |
| A 99 | 225 | 8.6% | |
| A 96 | 177 | 6.7% | |
| A 6 | 161 | 6.1% | |
| A 93 | 128 | 4.9% | |
| A 92 | 68 | 2.6% | |
| A 73 | 67 | 2.6% | |
| A 94 | 43 | 1.6% | |
| Other values (7) | 70 | 2.7% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.302591463 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7016006098 |
|---|---|
| Minimum | -1 |
| Maximum | 3 |
| Zeros | 763 |
| Zeros (%) | 29.1% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 3 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.4843542488 |
|---|---|
| Coefficient of variation (CV) | 0.690356083 |
| Kurtosis | -0.04465654628 |
| Mean | 0.7016006098 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.8475431605 |
| Sum | 1841 |
| Variance | 0.2345990383 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 1832 | 69.8% | |
| 0 | 763 | 29.1% | |
| -1 | 17 | 0.6% | |
| 2 | 10 | 0.4% | |
| 3 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| -1 | 17 | 0.6% | |
| 0 | 763 | 29.1% | |
| 1 | 1832 | 69.8% | |
| 2 | 10 | 0.4% | |
| 3 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 3 | 2 | 0.1% | |
| 2 | 10 | 0.4% | |
| 1 | 1832 | 69.8% | |
| 0 | 763 | 29.1% | |
| -1 | 17 | 0.6% |
Einzug
Real number (ℝ≥0)
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.483231707 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.61049529 |
|---|---|
| Coefficient of variation (CV) | 0.6485481341 |
| Kurtosis | -1.106773323 |
| Mean | 2.483231707 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.7690026967 |
| Sum | 6516 |
| Variance | 2.59369508 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2 | 979 | 37.3% | |
| 1 | 910 | 34.7% | |
| 5 | 721 | 27.5% | |
| 3 | 13 | 0.5% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 910 | 34.7% | |
| 2 | 979 | 37.3% | |
| 3 | 13 | 0.5% | |
| 4 | 1 | < 0.1% | |
| 5 | 721 | 27.5% |
| Value | Count | Frequency (%) | |
| 5 | 721 | 27.5% | |
| 4 | 1 | < 0.1% | |
| 3 | 13 | 0.5% | |
| 2 | 979 | 37.3% | |
| 1 | 910 | 34.7% |
Richtung
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.5 KiB |
| 1 | |
|---|---|
| 0 | 57 |
| Value | Count | Frequency (%) | |
| 1 | 2567 | 97.8% | |
| 0 | 57 | 2.2% |
| Distinct | 1237 |
|---|---|
| Distinct (%) | 47.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 947.3410823 |
|---|---|
| Minimum | 0 |
| Maximum | 24500 |
| Zeros | 756 |
| Zeros (%) | 28.8% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 292 |
| Q3 | 1228.25 |
| 95-th percentile | 3988.35 |
| Maximum | 24500 |
| Range | 24500 |
| Interquartile range (IQR) | 1228.25 |
Descriptive statistics
| Standard deviation | 1695.512711 |
|---|---|
| Coefficient of variation (CV) | 1.78975951 |
| Kurtosis | 35.62129468 |
| Mean | 947.3410823 |
| Median Absolute Deviation (MAD) | 292 |
| Skewness | 4.552555278 |
| Sum | 2485823 |
| Variance | 2874763.354 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 756 | 28.8% | |
| 100 | 18 | 0.7% | |
| 200 | 10 | 0.4% | |
| 150 | 10 | 0.4% | |
| 300 | 10 | 0.4% | |
| 65 | 9 | 0.3% | |
| 500 | 8 | 0.3% | |
| 52 | 7 | 0.3% | |
| 400 | 7 | 0.3% | |
| 97 | 6 | 0.2% | |
| Other values (1227) | 1783 | 67.9% |
| Value | Count | Frequency (%) | |
| 0 | 756 | 28.8% | |
| 8 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 26 | 1 | < 0.1% | |
| 27 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 24500 | 1 | < 0.1% | |
| 21032 | 1 | < 0.1% | |
| 17430 | 1 | < 0.1% | |
| 14185 | 1 | < 0.1% | |
| 13800 | 2 | 0.1% |
| Distinct | 482 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 360.5826982 |
|---|---|
| Minimum | 0 |
| Maximum | 187650 |
| Zeros | 421 |
| Zeros (%) | 16.0% |
| Memory size | 20.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 30 |
| Q3 | 98 |
| 95-th percentile | 553.85 |
| Maximum | 187650 |
| Range | 187650 |
| Interquartile range (IQR) | 94 |
Descriptive statistics
| Standard deviation | 4964.152373 |
|---|---|
| Coefficient of variation (CV) | 13.76702875 |
| Kurtosis | 983.8578272 |
| Mean | 360.5826982 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 29.48313023 |
| Sum | 946169 |
| Variance | 24642808.78 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 421 | 16.0% | |
| 1 | 91 | 3.5% | |
| 4 | 73 | 2.8% | |
| 2 | 64 | 2.4% | |
| 3 | 62 | 2.4% | |
| 7 | 41 | 1.6% | |
| 5 | 41 | 1.6% | |
| 9 | 36 | 1.4% | |
| 6 | 32 | 1.2% | |
| 15 | 30 | 1.1% | |
| Other values (472) | 1733 | 66.0% |
| Value | Count | Frequency (%) | |
| 0 | 421 | 16.0% | |
| 1 | 91 | 3.5% | |
| 2 | 64 | 2.4% | |
| 3 | 62 | 2.4% | |
| 4 | 73 | 2.8% |
| Value | Count | Frequency (%) | |
| 187650 | 1 | < 0.1% | |
| 132060 | 1 | < 0.1% | |
| 75330 | 1 | < 0.1% | |
| 39180 | 1 | < 0.1% | |
| 32130 | 1 | < 0.1% |
Month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.5 KiB |
| Jul | |
|---|---|
| Sep | |
| Oct | |
| Dec | |
| Aug | |
| Other values (7) |
| Value | Count | Frequency (%) | |
| Jul | 455 | 17.3% | |
| Sep | 303 | 11.5% | |
| Oct | 237 | 9.0% | |
| Dec | 232 | 8.8% | |
| Aug | 228 | 8.7% | |
| Apr | 226 | 8.6% | |
| May | 201 | 7.7% | |
| Mar | 180 | 6.9% | |
| Nov | 173 | 6.6% | |
| Jun | 149 | 5.7% | |
| Other values (2) | 240 | 9.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | TempMax | TempAvg | SpatMax | SpatAvg | TempDist | SpatDist | Coverage | TempGL | SpatGL | TempIL | SpatIL | TLCar | TLHGV | Strasse | AnzGesperrtFs | Einzug | Richtung | Length | Duration | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 69 | 30 | 15183 | 3134 | NaN | NaN | 18 | 3 | 2 | 3 | 2 | 1966 | 954 | A 9 | 1 | 2 | 1 | 0 | 18 | Jan |
| 1 | 1 | 69 | 30 | 15183 | 3134 | NaN | NaN | 18 | 2 | 2 | -1 | 4 | 1966 | 954 | A 9 | 1 | 1 | 1 | 13772 | 47 | Jan |
| 2 | 2 | 69 | 30 | 15183 | 3134 | NaN | NaN | 18 | 3 | 2 | 3 | 2 | 1966 | 954 | A 9 | 0 | 5 | 1 | 636 | 1 | Jan |
| 3 | 3 | 33 | 6 | 5301 | 1317 | NaN | NaN | 17 | 3 | 2 | 3 | 3 | 1131 | 856 | A 9 | 1 | 2 | 1 | 41 | 0 | Jan |
| 4 | 4 | 33 | 6 | 5301 | 1317 | NaN | NaN | 17 | 2 | 2 | -1 | 2 | 1131 | 856 | A 9 | 0 | 5 | 1 | 2603 | 45 | Jan |
| 5 | 5 | 33 | 6 | 5301 | 1317 | NaN | NaN | 17 | 3 | 2 | 4 | 4 | 1131 | 856 | A 9 | 0 | 5 | 1 | 258 | 8 | Jan |
| 6 | 6 | 174 | 156 | 15432 | 13788 | NaN | NaN | 88 | 3 | 2 | 2 | 1 | 1388 | 591 | A 7 | 1 | 1 | 1 | 1322 | 143 | Jan |
| 7 | 7 | 57 | 23 | 2210 | 1205 | NaN | NaN | 51 | 2 | 2 | -1 | 5 | 1143 | 580 | A 70 | 1 | 2 | 1 | 3246 | 407 | Jan |
| 8 | 10 | 60 | 43 | 2056 | 1310 | NaN | NaN | 73 | 2 | 2 | -1 | 3 | 1450 | 543 | A 70 | 1 | 2 | 0 | 0 | 62 | Jan |
| 9 | 11 | 60 | 17 | 6158 | 1409 | NaN | NaN | 21 | 3 | 2 | 3 | 2 | 1742 | 834 | A 6 | 1 | 2 | 1 | 3912 | 37 | Jan |
Last rows
| df_index | TempMax | TempAvg | SpatMax | SpatAvg | TempDist | SpatDist | Coverage | TempGL | SpatGL | TempIL | SpatIL | TLCar | TLHGV | Strasse | AnzGesperrtFs | Einzug | Richtung | Length | Duration | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2614 | 3229 | 360 | 306 | 14063 | 12907 | NaN | NaN | 91 | 3 | 2 | 3 | 3 | 1884 | 934 | A 3 | 1 | 2 | 1 | 0 | 3 | Dec |
| 2615 | 3230 | 75 | 35 | 6554 | 2934 | NaN | NaN | 43 | 2 | 2 | -1 | 5 | 1853 | 799 | A 3 | 1 | 1 | 1 | 1228 | 81 | Dec |
| 2616 | 3232 | 75 | 35 | 6554 | 2934 | NaN | 702.0 | 43 | 3 | 3 | 4 | -1 | 1853 | 799 | A 3 | 0 | 5 | 1 | 639 | 20 | Dec |
| 2617 | 3233 | 81 | 61 | 2698 | 2360 | NaN | NaN | 86 | 3 | 2 | 4 | 4 | 1305 | 511 | A 7 | 1 | 1 | 1 | 585 | 60 | Dec |
| 2618 | 3234 | 81 | 61 | 2698 | 2360 | NaN | NaN | 86 | 3 | 2 | 3 | 2 | 1305 | 511 | A 7 | 0 | 5 | 1 | 851 | 1 | Dec |
| 2619 | 3235 | 81 | 61 | 2698 | 2360 | NaN | NaN | 86 | 3 | 2 | 4 | 4 | 1305 | 511 | A 7 | -1 | 1 | 1 | 300 | 75 | Dec |
| 2620 | 3236 | 60 | 17 | 12219 | 4654 | NaN | NaN | 37 | 3 | 2 | 3 | 2 | 1671 | 871 | A 9 | 0 | 5 | 1 | 116 | 11 | Dec |
| 2621 | 3237 | 60 | 17 | 12219 | 4654 | NaN | NaN | 37 | 3 | 2 | 3 | 1 | 1671 | 871 | A 9 | 1 | 2 | 1 | 305 | 4 | Dec |
| 2622 | 3238 | 60 | 17 | 12219 | 4654 | NaN | NaN | 37 | 3 | 2 | 3 | 1 | 1671 | 871 | A 9 | 0 | 5 | 1 | 129 | 1 | Dec |
| 2623 | 3240 | 39 | 21 | 2218 | 967 | NaN | NaN | 42 | 2 | 2 | -1 | 2 | 1003 | 565 | A 73 | 1 | 2 | 1 | 1518 | 39 | Dec |